<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>Replication for Existing Databases in the SQL API</title>
    <link rel="stylesheet" href="gettingStarted.css" type="text/css" />
    <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
    <link rel="start" href="index.html" title="Berkeley DB Installation and Build Guide" />
    <link rel="up" href="upgrade_53_toc.html" title="Chapter 9.  Upgrading Berkeley DB 11.2.5.2 applications to Berkeley DB 11.2.5.3" />
    <link rel="prev" href="upgrade_11gr2_53_sql_pragma.html" title="New Berkeley DB SQL API PRAGMAs" />
    <link rel="next" href="upgrade_11gr2_53_xa_mvcc.html" title="Berkeley DB X/Open Compliant XA Resource Manager and Transaction Snapshots" />
  </head>
  <body>
    <div xmlns="" class="navheader">
      <div class="libver">
        <p>Library Version 11.2.5.3</p>
      </div>
      <table width="100%" summary="Navigation header">
        <tr>
          <th colspan="3" align="center">Replication for Existing Databases in the SQL API</th>
        </tr>
        <tr>
          <td width="20%" align="left"><a accesskey="p" href="upgrade_11gr2_53_sql_pragma.html">Prev</a> </td>
          <th width="60%" align="center">Chapter 9. 
        Upgrading Berkeley DB 11.2.5.2 applications to Berkeley DB 11.2.5.3
    </th>
          <td width="20%" align="right"> <a accesskey="n" href="upgrade_11gr2_53_xa_mvcc.html">Next</a></td>
        </tr>
      </table>
      <hr />
    </div>
    <div class="sect1" lang="en" xml:lang="en">
      <div class="titlepage">
        <div>
          <div>
            <h2 class="title" style="clear: both"><a id="upgrade_11gr2_53_sql_rep"></a>Replication for Existing Databases in the SQL API</h2>
          </div>
        </div>
      </div>
      <div class="toc">
        <dl>
          <dt>
            <span class="sect2">
              <a href="upgrade_11gr2_53_sql_rep.html#idp837896">PRAGMAs With Permanent Effects</a>
            </span>
          </dt>
          <dt>
            <span class="sect2">
              <a href="upgrade_11gr2_53_sql_rep.html#idp844568">PRAGMAs That Can Now Operate on Existing Databases</a>
            </span>
          </dt>
        </dl>
      </div>
      <p>
        Replication can now be enabled on existing SQL databases, and 
	replication is now disabled permanently instead of temporarily.  
	Replication is enabled on an existing database the same way it is 
	enabled on a new database, with one restriction.  The existing 
	database must configure itself as the initial master of a new 
	replication group.  To disable replication on a 
	database permanently, use <code class="literal">pragma replication=OFF;</code>.
    </p>
      <div class="sect2" lang="en" xml:lang="en">
        <div class="titlepage">
          <div>
            <div>
              <h3 class="title"><a id="idp837896"></a>PRAGMAs With Permanent Effects</h3>
            </div>
          </div>
        </div>
        <div class="itemizedlist">
          <ul type="disc">
            <li>
              <code class="literal">pragma replication=OFF;</code>
            </li>
          </ul>
        </div>
      </div>
      <div class="sect2" lang="en" xml:lang="en">
        <div class="titlepage">
          <div>
            <div>
              <h3 class="title"><a id="idp844568"></a>PRAGMAs That Can Now Operate on Existing Databases</h3>
            </div>
          </div>
        </div>
        <div class="itemizedlist">
          <ul type="disc">
            <li>
              <code class="literal">pragma replication_local_site="host:port";</code>
            </li>
            <li>
              <code class="literal">pragma replication_initial_master=ON;</code>
            </li>
            <li>
              <code class="literal">pragma replication=ON;</code>
            </li>
          </ul>
        </div>
      </div>
    </div>
    <div class="navfooter">
      <hr />
      <table width="100%" summary="Navigation footer">
        <tr>
          <td width="40%" align="left"><a accesskey="p" href="upgrade_11gr2_53_sql_pragma.html">Prev</a> </td>
          <td width="20%" align="center">
            <a accesskey="u" href="upgrade_53_toc.html">Up</a>
          </td>
          <td width="40%" align="right"> <a accesskey="n" href="upgrade_11gr2_53_xa_mvcc.html">Next</a></td>
        </tr>
        <tr>
          <td width="40%" align="left" valign="top">New Berkeley DB SQL API PRAGMAs </td>
          <td width="20%" align="center">
            <a accesskey="h" href="index.html">Home</a>
          </td>
          <td width="40%" align="right" valign="top"> Berkeley DB X/Open Compliant XA Resource Manager and Transaction Snapshots </td>
        </tr>
      </table>
    </div>
  </body>
</html>
